Why is there a syntax error when using GROUP BY in my SQL query

join shbcf.ru